Tabela TreatmentSchema

Definicja tabeli TreatmentSchema

Name

TreatmentSchema

Code

TreatmentSchema

Comment

 


Lista kolumn tabeli TreatmentSchema

Name

Code

TreatmentSchemaID

TreatmentSchemaID

ShortName

ShortName

FullName

FullName

Description

Description

Active

Active

StartDT

StartDT

StopDT

StopDT

SchemaLength

SchemaLength

Standard

Standard

Required

Required

KSSWDNo

KSSWDNo

SchemaDetails

SchemaDetails

Code

Code


Kolumna TreatmentSchemaID tabeli TreatmentSchema

Definicja kolumny TreatmentSchemaID tabeli TreatmentSchema

Name

TreatmentSchemaID

Code

TreatmentSchemaID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna ShortName tabeli TreatmentSchema

Definicja kolumny ShortName tabeli TreatmentSchema

Name

ShortName

Code

ShortName

Data Type

VARCHAR2(32)

Mandatory

No

Comment

PL: Skrócona nazwa wiersza
EN: Record's short name
DE: Der kurz Name des Rekord


Kolumna FullName tabeli TreatmentSchema

Definicja kolumny FullName tabeli TreatmentSchema

Name

FullName

Code

FullName

Data Type

VARCHAR2(255)

Mandatory

No

Comment

PL: Pelna nazwa wiersza
EN: Record's full name
DE: Der voll Name des Rekord


Kolumna Description tabeli TreatmentSchema

Definicja kolumny Description tabeli TreatmentSchema

Name

Description

Code

Description

Data Type

VARCHAR2(48)

Mandatory

No

Comment

PL: Opis wiersza
EN: Record's description
DE: Die Beschreibung des Rekord


Kolumna Active tabeli TreatmentSchema

Definicja kolumny Active tabeli TreatmentSchema

Name

Active

Code

Active

Data Type

NUMBER(5)

Mandatory

No

Comment

PL: Aktywnosc wiersza.
EN: Record's Activity
DE: Aktivitat des Rekord


Kolumna StartDT tabeli TreatmentSchema

Definicja kolumny StartDT tabeli TreatmentSchema

Name

StartDT

Code

StartDT

Data Type

DATE

Mandatory

No

Comment

PL: Data poczatku
EN: Start date
DE: das Beginndatum


Kolumna StopDT tabeli TreatmentSchema

Definicja kolumny StopDT tabeli TreatmentSchema

Name

StopDT

Code

StopDT

Data Type

DATE

Mandatory

No

Comment

PL: Data koncowa
EN: Stop date
DE: Das Endedatum


Kolumna SchemaLength tabeli TreatmentSchema

Definicja kolumny SchemaLength tabeli TreatmentSchema

Name

SchemaLength

Code

SchemaLength

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna Standard tabeli TreatmentSchema

Definicja kolumny Standard tabeli TreatmentSchema

Name

Standard

Code

Standard

Data Type

NUMBER(5)

Mandatory

No

Comment

 


Kolumna Required tabeli TreatmentSchema

Definicja kolumny Required tabeli TreatmentSchema

Name

Required

Code

Required

Data Type

NUMBER(5)

Mandatory

No

Comment

 


Kolumna KSSWDNo tabeli TreatmentSchema

Definicja kolumny KSSWDNo tabeli TreatmentSchema

Name

KSSWDNo

Code

KSSWDNo

Data Type

VARCHAR2(32)

Mandatory

No

Comment

 


Kolumna SchemaDetails tabeli TreatmentSchema

Definicja kolumny SchemaDetails tabeli TreatmentSchema

Name

SchemaDetails

Code

SchemaDetails

Data Type

CLOB

Mandatory

No

Comment

 


Kolumna Code tabeli TreatmentSchema

Definicja kolumny Code tabeli TreatmentSchema

Name

Code

Code

Code

Data Type

VARCHAR2(15)

Mandatory

No

Comment

PL: Kod wiersza
EN: Record's code
DE: Der code des Rekord


Lista kluczy tabeli TreatmentSchema

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli TreatmentSchema

Definicja klucza Identifier_1 tabeli TreatmentSchema

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment